Reloading the data mart
After columns have been added to dimension or fact tables as part of an adjust operation, you might want to load those columns with historical data. You can do this using the markReloadDatamartOnNextRun CLI. You mark the entire data mart to be reloaded on the next run, which might be useful if many columns have been added, or you can mark only specific facts or dimensions to be reloaded on the next run.
You can also mark dimensions and facts from several data marts to be reloaded on the next run or mark multiple data marts to be reloaded in their entirety (on the next run) using a CSV file.
Command syntax
ComposeCli.exe mark_reload_datamart_on_next_run --project project_name --datamart datamart_name [--fact fact_name|--dimension dimension_name|--csv csvfile_name] [--obsoleteallrecords]
Parameters
Parameter | Description |
---|---|
--project | The name of the project. |
--datamart | The name of the data mart containing the fact(s) or dimension(s) to be reloaded. |
--fact | The name of a specific fact you want to be reloaded. |
--dimension | The name of a specific dimension you want to be reloaded. Any facts related to these dimensions will also be reloaded to ensure that the data mart VIDs stay valid. |
--obsoleteallrecords |
Use this parameter to mark all of the existing dimension records as obsolete. You might need to do this if, for example, a new column was added to the dimension and you want to reload existing records with the new column. In such a case, you might want to preserve the old records as they were before the new column was added and populated. See also: The "Obsolete" indicator. |
--csv |
A CSV file containing a list of facts or dimensions from one or more data marts, or a list of data marts. Each row in the CSV file should also contain "yes" or "no", indicating whether or not to mark the records as obsolete. CSV file format: data mart,fact|dimension,yes|no
Example 1 - Reloading dimensions from two different data marts:
MyDataMart1,orders,no MyDataMart2,customers,yes Example 2 - Reloading two complete data marts:
MyDataMart1,,no
MyDataMart2,,no
|
Example
ComposeCli.exe mark_reload_datamart_on_next_run --project inventory --datamart MyDataMart --fact orders